A exclude constraint guarantees that if any two rows are compared on the specified column(s) or expression(s) using the specified operator(s), not all of these comparisons will return TRUE.
Excludes are managed on the Excludes tab of the Table Designer. Just simply click on an exclude field for editing. By using the toolbar below, you can create new, edit and delete the selected exclude field.
Note: Exclude is supported from PostgreSQL 9.0 or later.
Add Exclude
To add an exclude
- Open the table in the Table Designer.
- Open the Excludes tab.
- Click the
Add Exclude from the toolbar.
- Edit exclude properties.
Edit Exclude
To edit an exclude
- Open the table in the Table Designer.
- Open the Excludes tab.
- Just simply click on the exclude to edit.
Delete Exclude
To delete an exclude
- Open the table in the Table Designer.
- Open the Excludes tab.
- Click the
Delete Exclude from the toolbar.
- Confirm deleting in the dialog window.
See also:
Setting Exclude Properties